package org.jeecg.modules.marketingDepartment.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import org.jeecg.common.aspect.annotation.Dict;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.springframework.format.annotation.DateTimeFormat;

import java.io.Serializable;
import java.util.Date;

/**
 * @Description: 市场部数据表
 * @Author: jeecg-boot
 * @Date:   2023-11-09
 * @Version: V1.0
 */
@Data
@TableName("sy_marketing_department")
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
@ApiModel(value="sy_marketing_department对象", description="市场部数据表")
public class SyMarketingDepartment implements Serializable {
    private static final long serialVersionUID = 1L;

	/**主键*/
	@TableId(type = IdType.ASSIGN_ID)
    @ApiModelProperty(value = "主键")
    private String id;
	/**创建人*/
    @ApiModelProperty(value = "创建人")
    private String createBy;
	/**创建日期*/
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "创建日期")
    private Date createTime;
	/**更新人*/
    @ApiModelProperty(value = "更新人")
    private String updateBy;
	/**更新日期*/
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
    @ApiModelProperty(value = "更新日期")
    private Date updateTime;
	/**所属部门*/
    @ApiModelProperty(value = "所属部门")
    private String sysOrgCode;
	/**用户账号*/
	@Excel(name = "用户账号", width = 15)
    @ApiModelProperty(value = "用户账号")
    private String username;
	/**用户姓名*/
	@Excel(name = "用户姓名", width = 15)
    @ApiModelProperty(value = "用户姓名")
    private String realname;
	/**用户年龄*/
	@Excel(name = "用户年龄", width = 15)
    @ApiModelProperty(value = "用户年龄")
    private String age;
	/**用户电话*/
	@Excel(name = "用户电话", width = 15)
    @ApiModelProperty(value = "用户电话")
    private String phone;
	/**用户地址*/
	@Excel(name = "用户地址", width = 15)
    @ApiModelProperty(value = "用户地址")
    private String location;
	/**产品号码*/
	@Excel(name = "产品号码", width = 15)
    @ApiModelProperty(value = "产品号码")
    private String productNumber;
	/**产品实例ID*/
	@Excel(name = "产品实例ID", width = 15)
    @ApiModelProperty(value = "产品实例ID")
    private String productExampleId;
	/**合约名称*/
	@Excel(name = "合约名称", width = 15)
    @ApiModelProperty(value = "合约名称")
    private String contractName;
	/**合约结束时间*/
	@Excel(name = "合约结束时间", width = 15)
    @ApiModelProperty(value = "合约结束时间")
    private String contractEndTime;
	/**主套餐名称*/
	@Excel(name = "主套餐名称", width = 15)
    @ApiModelProperty(value = "主套餐名称")
    private String mainMealName;
	/**状态匹配*/
	@Excel(name = "状态匹配", width = 15)
    @ApiModelProperty(value = "状态匹配")
    private String stateMatching;
	/**网格名称（模糊匹配）*/
	@Excel(name = "网格名称（模糊匹配）", width = 15)
    @ApiModelProperty(value = "网格名称（模糊匹配）")
    private String griddingName;
	/**营业区(模糊匹配)*/
	@Excel(name = "营业区(模糊匹配)", width = 15)
    @ApiModelProperty(value = "营业区(模糊匹配)")
    private String businessQuarter;
	/**是否质差*/
	@Excel(name = "是否质差", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否质差")
    private String sfzc;
	/**宽带装机地址*/
	@Excel(name = "宽带装机地址", width = 15)
    @ApiModelProperty(value = "宽带装机地址")
    private String kdzjdz;
	/**宽带下行速率*/
	@Excel(name = "宽带下行速率", width = 15)
    @ApiModelProperty(value = "宽带下行速率")
    private Integer kdxxsl;
	/**是否E8-C终端*/
	@Excel(name = "是否E8-C终端", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否E8-C终端")
    private String e8C;
	/**近三月账户下平均出账收入(分摊前)1*/
	@Excel(name = "近三月账户下平均出账收入(分摊前)1", width = 15)
    @ApiModelProperty(value = "近三月账户下平均出账收入(分摊前)1")
    private String jsgyzhpjczsr;
	/**是否千兆光猫*/
	@Excel(name = "是否千兆光猫", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否千兆光猫")
    private String sfqzgm;
	/**是否终端硬合约*/
	@Excel(name = "是否终端硬合约", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否终端硬合约")
    private String sfzdyhy;
	/**是否端网不匹配*/
	@Excel(name = "是否端网不匹配", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否端网不匹配")
    private String sfdwbpp;
	/**是否近三个月障碍*/
	@Excel(name = "是否近三个月障碍", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否近三个月障碍")
    private String sfjsgyzi;
	/**是否中高值*/
	@Excel(name = "是否中高值", width = 15, dicCode = "yn")
	@Dict(dicCode = "yn")
    @ApiModelProperty(value = "是否中高值")
    private String sfzgz;
	/**欠费金额(截止昨日)*/
	@Excel(name = "欠费金额(截止昨日)", width = 15)
    @ApiModelProperty(value = "欠费金额(截止昨日)")
    private Double amountInArrear;
	/**终端速率*/
	@Excel(name = "终端速率", width = 15)
    @ApiModelProperty(value = "终端速率")
    private Integer terminalRate;
	/**省*/
	@Excel(name = "省", width = 15)
    @ApiModelProperty(value = "省")
    private String province;
	/**市*/
	@Excel(name = "市", width = 15)
    @ApiModelProperty(value = "市")
    private String city;
	/**区域*/
	@Excel(name = "区域", width = 15)
    @ApiModelProperty(value = "区域")
    private String area;
	/**光猫型号*/
	@Excel(name = "光猫型号", width = 15)
    @ApiModelProperty(value = "光猫型号")
    private String model;
	/**光猫是否不匹配*/
	@Excel(name = "光猫是否不匹配", width = 15)
    @ApiModelProperty(value = "光猫是否不匹配")
    private String gmsfbpp;
	/**游戏网站名称*/
	@Excel(name = "游戏网站名称", width = 15)
    @ApiModelProperty(value = "游戏网站名称")
    private String gameName;
	/**游戏下行累计流量(M)*/
	@Excel(name = "游戏下行累计流量(M)", width = 15)
    @ApiModelProperty(value = "游戏下行累计流量(M)")
    private String gameDown;
	/**游戏上行累计流量(M)*/
	@Excel(name = "游戏上行累计流量(M)", width = 15)
    @ApiModelProperty(value = "游戏上行累计流量(M)")
    private String gameUp;
	/**日均时长/游戏总时长(h)*/
	@Excel(name = "日均时长/游戏总时长(h)", width = 15)
    @ApiModelProperty(value = "日均时长/游戏总时长(h)")
    private String gameDaot;
	/**日均流量/游戏总流量(M)*/
	@Excel(name = "日均流量/游戏总流量(M)", width = 15)
    @ApiModelProperty(value = "日均流量/游戏总流量(M)")
    private String gameRateOfFlow;
	/**游戏质差次数*/
	@Excel(name = "游戏质差次数", width = 15)
    @ApiModelProperty(value = "游戏质差次数")
    private String gameZccs;
	/**游戏质差时长占比(%)*/
	@Excel(name = "游戏质差时长占比(%)", width = 15)
    @ApiModelProperty(value = "游戏质差时长占比(%)")
    private String gameProportion;
	/**游戏上行平均时延(ms)*/
	@Excel(name = "游戏上行平均时延(ms)", width = 15)
    @ApiModelProperty(value = "游戏上行平均时延(ms)")
    private String gameUpDefer;
	/**游戏下行平均时延(ms)*/
	@Excel(name = "游戏下行平均时延(ms)", width = 15)
    @ApiModelProperty(value = "游戏下行平均时延(ms)")
    private String gameDownDefer;
	/**游戏上行平均抖动(ms)*/
	@Excel(name = "游戏上行平均抖动(ms)", width = 15)
    @ApiModelProperty(value = "游戏上行平均抖动(ms)")
    private String gameUpShake;
	/**游戏下行平均抖动(ms)*/
	@Excel(name = "游戏下行平均抖动(ms)", width = 15)
    @ApiModelProperty(value = "游戏下行平均抖动(ms)")
    private String gameDownShake;
	/**主播网站名称*/
	@Excel(name = "主播网站名称", width = 15)
    @ApiModelProperty(value = "主播网站名称")
    private String anchorName;
	/**主播下行累计流量(M)*/
	@Excel(name = "主播下行累计流量(M)", width = 15)
    @ApiModelProperty(value = "主播下行累计流量(M)")
    private String anchorDown;
	/**主播上行累计流量(M)*/
	@Excel(name = "主播上行累计流量(M)", width = 15)
    @ApiModelProperty(value = "主播上行累计流量(M)")
    private String anchorUp;
	/**日均时长/主播总时长(h)*/
	@Excel(name = "日均时长/主播总时长(h)", width = 15)
    @ApiModelProperty(value = "日均时长/主播总时长(h)")
    private String anchorDaot;
	/**日均流量/主播总流量(M)*/
	@Excel(name = "日均流量/主播总流量(M)", width = 15)
    @ApiModelProperty(value = "日均流量/主播总流量(M)")
    private String anchorRateOfFlow;
	/**主播质差次数*/
	@Excel(name = "主播质差次数", width = 15)
    @ApiModelProperty(value = "主播质差次数")
    private String anchorZccs;
	/**主播质差时长占比(%)*/
	@Excel(name = "主播质差时长占比(%)", width = 15)
    @ApiModelProperty(value = "主播质差时长占比(%)")
    private String anchorProportion;
	/**主播上行平均时延(ms)*/
	@Excel(name = "主播上行平均时延(ms)", width = 15)
    @ApiModelProperty(value = "主播上行平均时延(ms)")
    private String anchorUpDefer;
	/**主播下行平均时延(ms)*/
	@Excel(name = "主播下行平均时延(ms)", width = 15)
    @ApiModelProperty(value = "主播下行平均时延(ms)")
    private String anchorDownDefer;
	/**主播上行平均抖动(ms)*/
	@Excel(name = "主播上行平均抖动(ms)", width = 15)
    @ApiModelProperty(value = "主播上行平均抖动(ms)")
    private String anchorUpShake;
	/**主播下行平均抖动(ms)*/
	@Excel(name = "主播下行平均抖动(ms)", width = 15)
    @ApiModelProperty(value = "主播下行平均抖动(ms)")
    private String anchorDownShake;
}
